CREATE EXTERNAL TABLE jms_dm.dm_waybill_customer_complaint_network_agg_new_hi
(
    regional_code              string COMMENT '大区编码',
    regional_desc              string COMMENT '大区名称',
    network_code               string COMMENT '网点编码',
    network_name               string COMMENT '网点名称',
    fran_code                  string COMMENT '加盟商code',
    fran_name                  string COMMENT '加盟商name',
    agent_code                 string COMMENT '代理区code',
    agent_name                 string COMMENT '代理区name',
    virt_code                  string COMMENT '虚拟代理区code',
    virt_name                  string COMMENT '虚拟代理区name',
    zone_id                    string COMMENT '市场片区id',
    zone_code                  string COMMENT '市场片区code',
    zone_name                  string COMMENT '市场片区name',
    sys_area_id                string COMMENT '网管父片区id',
    parent_area_code           string COMMENT '网管父片区域code',
    parent_area_name           string COMMENT '网管父片区域name',
    area_code                  string COMMENT '网管子片区域name',
    area_name                  string COMMENT '网管子片区域name',
    network_type               string COMMENT '网点类型',
    is_virtual_agent           int COMMENT '1是虚拟代理区,2不是',
    work_cnt                   bigint COMMENT '呼叫中心客诉量',
    work_total                 bigint COMMENT '呼叫中心客诉量汇总',
    project_cnt                bigint COMMENT '平台客诉量',
    project_total              bigint COMMENT '平台客诉量汇总',
    appeal_cnt                 bigint COMMENT '邮政客诉量',
    appeal_total               bigint COMMENT '邮政客诉量汇总',
    claim_cnt                  bigint COMMENT '理赔客诉量',
    claim_total                bigint COMMENT '理赔客户量汇总',
    third_platform_cnt         bigint COMMENT '第三方客诉量',
    third_platform_ratio       decimal(10, 2) COMMENT '第三方客诉率',
    third_platform_total       bigint COMMENT '第三方客诉量汇总',
    third_platform_total_ratio decimal(10, 2) COMMENT '第三方汇总客诉率',
    transfer_cnt               bigint COMMENT '转运客诉量',
    transfer_cnt_ratio         decimal(10, 2) COMMENT '转运客诉率',
    transfer_total             bigint COMMENT '转运客诉量-全网',
    transfer_total_ratio       decimal(10, 2) COMMENT '转运客诉率-全网',
    network_cnt                bigint COMMENT '网点客诉量',
    network_total              bigint COMMENT '网点累计客诉量',
    network_ratio              decimal(10, 2) COMMENT '网点客诉率',
    network_total_ratio        decimal(10, 2) COMMENT '网点累计客诉率',
    all_cnt                    bigint COMMENT '全网客诉量',
    all_ratio                  decimal(10, 2) COMMENT '全网客诉率',
    all_total                  bigint COMMENT '全网客诉量汇总',
    all_total_ratio            decimal(10, 2) COMMENT '全网客诉率汇总',
    taking_cnt                 bigint COMMENT '网点出件量',
    arrival_cnt                bigint COMMENT '网点到件量',
    taking_total               bigint COMMENT '全网出件量',
    arrival_total              bigint COMMENT '全网到件量',
    data_time                  string COMMENT '工单日期',
    xijia_sign_num             int COMMENT '虚假签收',
    over_time_num              int COMMENT '超时效催件',
    have_take_no_send_num      int COMMENT '有揽未发',
    no_send_door_num           int COMMENT '不送货上门',
    service_attitude_num       int COMMENT '服务态度',
    money_problem_num          int COMMENT '费用问题',
    out_complaint_num          int COMMENT '外投诉意向',
    compensate_num             int COMMENT '赔偿意向',
    reback_transfer_num        int COMMENT '退转件票数',
    center_op                  int COMMENT '中心操作量'
)
    COMMENT '客诉量网点汇总'
    PARTITIONED BY (
        dt string COMMENT '分区字段')
    STORED AS parquet
    LOCATION
        '/dw/hive/jms_dm.db/external/dm_waybill_customer_complaint_network_agg_new_hi'